 $sth = $this->db->prepare("SELECT 
            makul.nama, data.id, data.nilai 
            FROM 
            makul
            INNER JOIN
            data
            where
            makul.kd_makul = data.kd_makul
            and
            id=:id");

        $sth->execute(array(
            ':id' => $data
        ));

        $result = $sth->fetch();
//        print_r($result);
        return $result;